package com.zhao.dao;

import com.zhao.pojo.DrivingLicense;
import com.zhao.pojo.SchoolCounsellor;
import org.apache.ibatis.annotations.Mapper;

import javax.servlet.http.HttpSession;
import java.util.List;

@Mapper
public interface DrivingLicenseDao {



    List<DrivingLicense> findByStatusAndUniversityID(String status,String universityID);
    List<DrivingLicense> findByStatusAndApproverIDAndUniversityID(String status,String approverID ,String universityID);
    DrivingLicense findByEbickID(String ebickID,String universityID);


    DrivingLicense findByStudentID(String studentID,String universityID);
    DrivingLicense findByStudentIDAndStatus(String studentID,String status,String universityID);
    DrivingLicense findByID(String drivingLicenseID ,String universityID);
    int add(DrivingLicense drivingLicense);
    int update(DrivingLicense drivingLicense);
    int deleteByID(String drivingLicenseID,String universityID);

    List<DrivingLicense> findAll(String universityID);


}
